Fixed Assets Tables

Note: Rows and/or Tables marked with an asterisk (*) are added to Traverse Global. Rows and/or Tables marked with a negative asterisk (-*) refer to tables and/or rows that are removed in Traverse Global.

Column Name Column Type Length Default Value Description Enumeration
AssetID pAssetID 15      
AssetPrefix nvarchar 9      
TaxDist1 nvarchar 15      
TaxDist2 nvarchar 15      
TaxDist3 nvarchar 15      
Locat1 nvarchar 15      
Locat2 nvarchar 15      
Locat3 nvarchar 15      
AssetStatus tinyint 1 -1 Asset Status 1 = Active, 2 = Retired, 3 = New, 4 = Suspended
OwnedAsset bit 1   Owned / Leased Asset Flag 0 = Leased, 1 = Owned
NewAsset bit 1   New / Used Asset Flag 0 = Used, 1 = New
PersonalProperty bit 1   Personal / Real Estate Asset Flag 0 = Real Estate, 1 = Personal
ListedProperty bit 1      
InsurableProperty bit 1      
AssetClass nvarchar 6      
TaxClass nvarchar 4      
GLAsset pGlAcct 255      
GLAccum pGlAcct 255      
GLExpense pGlAcct 255      
AcquisitionCost pDecimal 13 0    
AcquisitionDate datetime 8      
RetirementDate datetime 8      
Qty int 4 0    
InsuredValue pDecimal 13 0    
InsuredValueDate datetime 8      
AssessedValue pDecimal 13 0    
AssessedValueDate datetime 8      
ReplaceCost pDecimal 13 0    
ReplaceCostDate datetime 8      
PlacedInServDate datetime 8      
TaxPaid pDecimal 13 0    
AccumNonDeprcCost pDecimal 13 0    
AdjustedCost pDecimal 13 0    
AdjustedDate datetime 8      
TotalCredits pDecimal 13 0    
CF xml -1      
ts timestamp 8      
AssetDescr pDescription 255      
BonusDeprPct pDecimal 13 0    
CreditDescr pDescription 255      
Manufacturer pDescription 255      
ModelNo pDescription 255      
NoteField varchar max      
SerialNo pDescription 255      
TagNo pDescription 255      
*CurrencyID pCurrency 6      
Column Name Column Type Length Default Value Description Enumeration
ID int 4      
AssetID pAssetID 15      
DeprcType nvarchar 6      
Method nvarchar 6      
AppyBusinessUse tinyint 1 -1    
SwitchMethod nvarchar 6      
BeginYr int 4      
BeginPd smallint 2      
EndYr int 4      
EndPd smallint 2      
Life pDecimal 13      
Recovery int 4      
BaseCost pDecimal 13      
SalvageValue pDecimal 13      
BonusDepr pDecimal 13      
Expense179 pDecimal 13      
Credits pDecimal 13      
TotDeprElig pDecimal 13      
AnnualDepr pDecimal 13      
CurrDepr pDecimal 13      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Amount pDecimal 13      
DeprID int 4      
EntryDate datetime 8      
FiscalPeriod smallint 2      
FiscalYear smallint 2      
GLAccumDepr pGlAcct 40      
GLExpense pGlAcct 40      
ID int 4      
PostRun pPostRun 14      
TransDate datetime 8      
TransType smallint 2   Transaction Type 0 = Regular Depreciation, 1 = Retirement Depreciation
ts timestamp 8      
CF xml -1      
*AmountBase pDecimal 13      
Column Name Column Type Length Default Value Description Enumeration
ID int 4      
AssetID pAssetID 15      
ServiceDateSched datetime 8      
ServiceDateAct datetime 8      
CF xml -1      
ts timestamp 8      
ServDescr pDescription 255      
Column Name Column Type Length Default Value Description Enumeration
DeprType nvarchar 6      
PdInYr smallint 2      
PdProcessed smallint 2      
BeginPd smallint 2      
EndPd smallint 2      
FiscalYear smallint 2      
GLPd smallint 2      
Process tinyint 1      
SortOrder smallint 2      
CF xml -1      
ts timestamp 8      
Type tinyint 1   Depreciation Type 0 = Other, 1 = Book, 2 = FedTax, 3 = AltMinTax
Column Name Column Type Length Default Value Description Enumeration
RetirementID int 4      
AssetID pAssetID 15      
AssetPrefix nvarchar 9      
TaxDist1 nvarchar 15      
TaxDist2 nvarchar 15      
TaxDist3 nvarchar 15      
Locat1 nvarchar 15      
Locat2 nvarchar 15      
Locat3 nvarchar 15      
AssetStatus tinyint 1 0 Asset Status 1 = Active, 2 = Retired, 3 = New, 4 = Suspended
OwnedAsset bit 1      
NewAsset bit 1      
PersonalProperty bit 1      
ListedProperty bit 1      
InsurableProperty bit 1      
AssetClass nvarchar 6      
TaxClass nvarchar 4      
GLAsset pGlAcct 255      
GLAccum pGlAcct 255      
GLExpense pGlAcct 255      
AcquisitionCost pDecimal 13 0    
AcquisitionDate datetime 8      
RetirementDate datetime 8      
Qty int 4 0    
InsuredValue pDecimal 13 0    
InsuredValueDate datetime 8      
AssessedValue pDecimal 13 0    
AssessedValueDate datetime 8      
ReplaceCost pDecimal 13 0    
ReplaceCostDate datetime 8      
PlacedInServDate datetime 8      
TaxPaid pDecimal 13 0    
AccumNonDeprcCost pDecimal 13 0    
AdjustedCost pDecimal 13 0    
AdjustedDate datetime 8      
TotalCredits pDecimal 13 0    
RetireCode nvarchar 1      
RetireDate datetime 8      
RetireQty int 4 0    
RetireAmt pDecimal 13 0    
RetireProceeds pDecimal 13 0    
RetireExpense pDecimal 13 0    
RetireCredits pDecimal 13 0    
RetireAcqCosts pDecimal 13 0    
AssetDescr pDescription 255      
BonusDeprPct pDecimal 13 0    
CreditDescr pDescription 255      
Manufacturer pDescription 255      
ModelNo pDescription 255      
NoteField varchar max      
RetireReason pDescription 255      
SerialNo pDescription 255      
TagNo pDescription 255      
CF xml -1      
ts timestamp 8      
*CurrencyID pCurrency 6      
Column Name Column Type Length Default Value Description Enumeration
ID int 4      
RetirementID int 4      
AssetID pAssetID 15      
DeprcType nvarchar 6      
Method nvarchar 6      
AppyBusinessUse tinyint 1 -1    
SwitchMethod nvarchar 6      
BeginYr int 4      
BeginPd smallint 2      
EndYr int 4      
EndPd smallint 2      
Life pDecimal 13      
Recovery int 4      
ActLife int 4      
BaseCost pDecimal 13      
SalvageValue pDecimal 13      
BonusDepr pDecimal 13      
Expense179 pDecimal 13      
Credits pDecimal 13      
TotDeprTaken pDecimal 13      
TotDeprElig pDecimal 13      
YTDDepr pDecimal 13      
AnnualDepr pDecimal 13      
CF xml -1      
ts timestamp 8      

tblFaTaxHdr -- FA Tax Header table

tblFaTaxDtl -- FA Tax Detail table